Amanda Carta
Amanda Carta
Reactions
-
Re: IF(ISERROR OR IF(ISERROR THEN...
AH HA!!! I got it! :) Thank you for making me think outside the box. I was so stuck on Vlookup :) =IF(SUM(COUNTIF({Sheet1 Range 2}, Output@row) + COUNTIF({Sheet2 Range 2}, Output@row)) > 0, "…1 · -
Re: Can I hide a row once a status is marked as complete in a column using conditional formatting?
You can via filters but it doesn't have the functionality like Excel. The filter would be to exclude anything in Status that says Closed. One thing I did for this same need is just have those rows mo…1 · -
Re: Add Formatting to Column Headers
This would really help eliminate the need to have the entire row highlight to showcase specific columns to certain departments other than adding their dpt name in the title.1 · -
Re: Automation
You can have it change a cell value when a Document is Added and/or Changed but the only downfall is it doesn't let you label the document being added so if you have multiple docs then if they are ad…1 · -
Re: Leave field Blank when using IF formula, on Date Row.
Anytime :)1 ·
